---
title: SAIF.Business.View.Policy SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Corporation
last_reviewed: 2026-08-21
library: SAIF.Business.View.Policy
reference_type: embedded
---

# SAIF.Business.View.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](./SQL-001-getpolicyaffiliatelist.md) | Retrieve affiliated policies by affiliate type | Stored Proc | N/A — stored procedure | `clsAffiliatedPolicyCollection` |
| [SQL-002](./SQL-002-getagency.md) | Retrieve agency for a policy | Stored Proc | N/A — stored procedure | `clsAgency` |
| [SQL-003](./SQL-003-period-date-query.md) | Retrieve latest issued policy period dates | Inline | POLICY_PERIOD_ALL, ENDORSEMENT, POLICY_PERIOD_NON_WCIS | `clsAssociationTypeCode` |
| [SQL-004](./SQL-004-non-typed-association-lookup.md) | Retrieve non-typed policy associations | Stored Proc | N/A — stored procedure | `clsAssociationTypeCode` |
| [SQL-005](./SQL-005-association-type-code-lookup.md) | Retrieve association type code definitions | Inline | ASSOCIATION_TYPE_CODE | `clsAssociationTypeCodeCollection` |
| [SQL-006](./SQL-006-non-employer-account-lookup.md) | Retrieve non-employer account by number | Inline | NON_EMPR_ACCT | `clsNonEmployerAccount` |
| [SQL-007](./SQL-007-getpolicyaddress.md) | Retrieve policy address by type | Stored Proc | N/A — stored procedure | `clsPolicyAddress` |
| [SQL-008](./SQL-008-getpolicyaddressbylocseqnum.md) | Retrieve policy address by location | Stored Proc | N/A — stored procedure | `clsPolicyAddress` |
| [SQL-009](./SQL-009-officer-of-notice-lookup.md) | Retrieve officer of notice name | Inline | BUSINESS_AFFILIATE, AFFILIATE | `clsPolicyAddress` |
| [SQL-010](./SQL-010-getpolicy.md) | Retrieve core policy data | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-011](./SQL-011-getviewdetail.md) | Retrieve lazy-loaded policy detail | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-012](./SQL-012-get-policy-waiver-count.md) | Retrieve policy waiver count | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-013](./SQL-013-getparentpolicy.md) | Retrieve parent policy number | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-014](./SQL-014-getpolicyaffiliatetype.md) | Retrieve policy affiliate type | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-015](./SQL-015-secondary-policy-status.md) | Retrieve secondary policy status | Inline | DUAL | `clsPolicyData` |
| [SQL-016](./SQL-016-coverage-bound-flag.md) | Retrieve coverage bound flag | Inline | DUAL | `clsPolicyData` |
| [SQL-017](./SQL-017-info-page-printed.md) | Retrieve information-page printed flag | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-018](./SQL-018-getgaps.md) | Retrieve policy gaps | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-019](./SQL-019-last-audit-date.md) | Retrieve last completed final-audit date | Inline | PA_AUDIT | `clsPolicyData` |
| [SQL-020](./SQL-020-future-cancel-date.md) | Retrieve latest future cancel date | Inline | CANCELLATION | `clsPolicyData` |
| [SQL-021](./SQL-021-getspecificlimitsforpolicynum.md) | Retrieve employer liability limits | Stored Proc | N/A — stored procedure | `clsPolicyPeriod` |
| [SQL-022](./SQL-022-getpolicyperiods.md) | Retrieve policy periods | Stored Proc | N/A — stored procedure | `clsPolicyPeriodCollection` |
| [SQL-023](./SQL-023-cp-policy-in-group.md) | Check group access for policy | Stored Proc (SQL Server) | N/A — stored procedure | `clsPolicySecurity` |
| [SQL-024](./SQL-024-auditor-access-count.md) | Count auditor access matches | Inline | PA_AUDIT, PA_AUDITOR, PA_POLICY_PERIOD | `clsPolicySecurity` |
| [SQL-025](./SQL-025-cp-claimprofile-get-group-policy-list.md) | Retrieve accessible policies for group | Stored Proc (SQL Server) | N/A — stored procedure | `clsPolicySecurity` |
| [SQL-026](./SQL-026-cp-claimprofile-get-sc-book.md) | Retrieve accessible policies for safety consultant | Stored Proc (SQL Server) | N/A — stored procedure | `clsPolicySecurity` |
| [SQL-027](./SQL-027-cp-get-agent-online-policy-list.md) | Retrieve accessible policies for agent | Stored Proc (SQL Server) | N/A — stored procedure | `clsPolicySecurity` |
| [SQL-028](./SQL-028-fee-auditor-policy-list.md) | Retrieve accessible policies for fee auditor | Inline | PA_AUDIT, PA_AUDITOR, POLICY | `clsPolicySecurity` |
| [SQL-029](./SQL-029-cp-external-client-lookup.md) | Retrieve external client email | Stored Proc (SQL Server) | N/A — stored procedure | `clsTeamAssignment` |
| [SQL-030](./SQL-030-sp73341-external-client-lookup.md) | Retrieve external email by system user | Stored Proc | N/A — stored procedure | `clsTeamAssignment` |
| [SQL-031](./SQL-031-team-assign-query.md) | Retrieve policy service team | Stored Proc | N/A — stored procedure | `clsTeamAssignmentCollection` |
| [SQL-032](./SQL-032-trading-as-by-seq-num.md) | Retrieve trading-as by sequence number | Inline | TRADING_AS | `clsTradingAs` |
| [SQL-033](./SQL-033-trading-as-by-policy-num.md) | Retrieve trading-as by policy number | Inline | TRADING_AS | `clsTradingAsCollection` |
| [SQL-034](./SQL-034-policy-association-list.md) | Retrieve policy association list | Inline | POLICY_RELATIONSHIP, POLICY, COMBO_POLICY_PERIOD, POLICY_PERIOD, ER_COMBINATION_POLICY | `PolicyAssociationList` |
| [SQL-035](./SQL-035-max-policy-effective-date.md) | Retrieve maximum policy effective date | Inline | POLICY_PERIOD | `PolicyAssociationList` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb`
- `SAIF.Business.View.Policy/Associations/clsAssociationTypeCodeCollection.vb`
- `SAIF.Business.View.Policy/PolicyAssociations.vb`
- `SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb`
- `SAIF.Business.View.Policy/clsAgency.vb`
- `SAIF.Business.View.Policy/clsNonEmployerAccount.vb`
- `SAIF.Business.View.Policy/clsPolicyAddress.vb`
- `SAIF.Business.View.Policy/clsPolicyData.vb`
- `SAIF.Business.View.Policy/clsPolicyPeriod.vb`
- `SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb`
- `SAIF.Business.View.Policy/clsPolicySecurity.vb`
- `SAIF.Business.View.Policy/clsTeamAssignment.vb`
- `SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb`
- `SAIF.Business.View.Policy/clsTradingAs.vb`
- `SAIF.Business.View.Policy/clsTradingAsCollection.vb`